Adding or removing filter ranges

You can add one or more values to the Ranges column using the Range Builder. Values that match any of the ranges in the list are included in the replication.

You can also delete a filter range using the Range Builder.

To use the Range Builder:

1. In the Filter tab of the Table Settings window, select a column to filter. For more information, see Using filters.

2. Click the button to the right of the Ranges column.

   The Ranges Builder opens.

3. Click Add Range. Select any of the following from the drop-down list displayed.

   • Equal to: Select Equal to to enter a single value. The following is displayed in the range list.

     Equal to = [N]

     Click the [N] and type a value in the field that is displayed.

     When the value in the selected column equals the value you enter, the result is included or excluded in the replication task depending on the option selected in the Include/Exclude column.

   • Between: Click Between to enter a range of values. The following is displayed in the range list.

     Between [N] - [N]

     Click each [N] and type a value in the fields that are displayed.

     When the column contains the values between the two values entered, the result is included or excluded in the replication task depending on the option selected in the Include/Exclude column.

   • Less than or equal to: Select Less than or equal to and enter a maximum value. The following is displayed in the range list.

     Less than or Equal to =< [N]

     Click the [N] and type a value in the field that is displayed.

     When the value in the selected column is equal to or less than the value you enter, the result is included or excluded in the replication task depending on the option selected in the Include/Exclude column.

   • Greater than or equal to: Select Greater than or equal to and enter a minimum value. The following is displayed in the range list.

     Greater than or Equal to => [N]

     Click the [N] and type a value in the field that is displayed.

     When the value in the selected column is equal to or more than the value you enter, the result is included or excluded in the replication task depending on the option selected in the Include/Exclude column.

To delete a filter range from the Range Builder:

1. In the Filter tab of the Table Settings window, select the column with the filter condition you want to delete.
2. Click the button to the right of the Ranges column. The Ranges Builder opens.
3. Click the X next to the range you want to delete. The deleted range is removed from the list.